﻿create procedure [dbo].[usp_UpdateEmployee]
@Id as int,
@FirstName as nvarchar(100),
@LastName as nvarchar(100),
@NickName as nvarchar(100),
@DOB as datetime,
@RoleId as int
as
Update TblEmployee set FirstName=@FirstName,LastName=@LastName,NickName=@NickName,DOB=@DOB,RoleId=@RoleId
where Id=@Id


